Change a Datasource
Once you have created a Datasource, you may need to configure it, e.g. to change its name, or later you might want to make changes, e.g. to give it a different name or change the connection string. However, for Digitise Forms Datasources you don't need to specify the connection string within the Datasource properties as you can specify it in the Publishing Profile when you publish your form. The Publishing Profiles allow you to easily use different SQL databases for the same form, for example to switch between running the form in your test, development and live environments. See the
For information about changing a Datasource for an Imported Stored Procedure rather than a Digitise Forms or Imported Datasource, see Change an Imported Stored Procedure instead of this
Changes can be made in the properties of a Datasource and in the Project Explorer's Project and Datasources tabs:
To display a Datasource's properties, select the Datasource in either the Datasources or Project tab.
Selecting the Datasource in the Datasources tab will also display any Datasets, associated with the selected Datasource, in the Form Design workspace area of the Form Studio window.
The following properties are available:
A name of your choice to identify this Datasource.
We recommend that you don't give your Datasource a name which corresponds to any reserved words. Reserved words are words which are used internally within Digitise Forms or have a special meaning within JavaScript and generally cannot be used for user-definable items, such as a Datasource name. For example, you should not call a Datasource: submit, onsubmit, history or images, although SubmitData, CustHistory etc. could be used. For a list of typical reserved words see: https://www.w3schools.com/js/js_reserved.asp.
Note that right-clicking on this field and choosing Reset to default will clear the field.
This is the name of the Datasource's global object as you need to refer to it within any custom JavaScript functions you add to the form. Note that the name spelling here is case-sensitive and must be used in your JavaScript exactly as it appears here.
Connection Category
The options in this section can be used to enter, view and edit the connection string for the Datasource. However, as mentioned above you can also enter and edit the connection string within the Publishing Profile for the form, when you publish the form, and we recommend that this is where you do this.
However, if you want to enter, view or edit the connection details here, click on the browse button, 
, at the end of the Connection String text box to display the SQL Database Connection dialog.
Below the Connection String property, you will see the Catalog and Server Instance properties. The Catalog property displays the database name for the Datasource - 'catalog' is just another name for databases in SQL Server - and the Server Instance property displays the name of the machine hosting the SQL Server you want to use. These properties are for information only and cannot be edited separately from the SQL database Connection dialog.
Right-clicking on a Datasource in either the Datasources or Project tabs will display a context-sensitive menu.
The Datasources tab context menu has the following options:
This option is only available for Imported Datasources.
It allows you to change the connection string for the Datasource and create the required Dataset(s). Selecting this option will take you through the same process as creating a new Imported Datasource.
Note that if you include tables which were included before, this option doesn't remap previously unmapped columns so if you want to remap any unmapped columns you will need to do this manually in the Mappings tab for the Dataset.
This option is only available for Imported Datasources.
It allows you to change which of the remote database's tables are included in the current Datasource. This option displays the table mapping dialog used when creating a new Imported Datasource.
Note that if you include tables which were included before, this option doesn't remap previously unmapped columns so if you want to remap any unmapped columns you will need to do this manually in the Mappings tab for the Dataset.
This option is only available for Digitise Forms Datasources.
Allows you to create a new Dataset for the current Datasource.
Deletes the current Datasource and all its Datasets from your project.